package com.ttj.domain.oracle.gen;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class OrderPurchaseCriteria {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Integer mysqlOffset;

    protected Integer mysqlLength;

    public OrderPurchaseCriteria() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     * @param mysqlOffset 
	 *            指定返回记录行的偏移量<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public void setMysqlOffset(Integer mysqlOffset) {
        this.mysqlOffset=mysqlOffset;
    }

    /**
     * @param mysqlLength 
	 *            指定返回记录行的最大数目<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public Integer getMysqlOffset() {
        return mysqlOffset;
    }

    /**
     * @param mysqlOffset 
	 *            指定返回记录行的偏移量<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public void setMysqlLength(Integer mysqlLength) {
        this.mysqlLength=mysqlLength;
    }

    /**
     * @param mysqlLength 
	 *            指定返回记录行的最大数目<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public Integer getMysqlLength() {
        return mysqlLength;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("ID =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("ID <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("ID >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("ID >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("ID <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("ID <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("ID in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("ID not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("ID between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("ID not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNull() {
            addCriterion("ORDER_ID is null");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNotNull() {
            addCriterion("ORDER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andOrderIdEqualTo(Integer value) {
            addCriterion("ORDER_ID =", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotEqualTo(Integer value) {
            addCriterion("ORDER_ID <>", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThan(Integer value) {
            addCriterion("ORDER_ID >", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("ORDER_ID >=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThan(Integer value) {
            addCriterion("ORDER_ID <", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThanOrEqualTo(Integer value) {
            addCriterion("ORDER_ID <=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdIn(List<Integer> values) {
            addCriterion("ORDER_ID in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotIn(List<Integer> values) {
            addCriterion("ORDER_ID not in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdBetween(Integer value1, Integer value2) {
            addCriterion("ORDER_ID between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotBetween(Integer value1, Integer value2) {
            addCriterion("ORDER_ID not between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andCIdIsNull() {
            addCriterion("C_ID is null");
            return (Criteria) this;
        }

        public Criteria andCIdIsNotNull() {
            addCriterion("C_ID is not null");
            return (Criteria) this;
        }

        public Criteria andCIdEqualTo(Integer value) {
            addCriterion("C_ID =", value, "cId");
            return (Criteria) this;
        }

        public Criteria andCIdNotEqualTo(Integer value) {
            addCriterion("C_ID <>", value, "cId");
            return (Criteria) this;
        }

        public Criteria andCIdGreaterThan(Integer value) {
            addCriterion("C_ID >", value, "cId");
            return (Criteria) this;
        }

        public Criteria andCIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("C_ID >=", value, "cId");
            return (Criteria) this;
        }

        public Criteria andCIdLessThan(Integer value) {
            addCriterion("C_ID <", value, "cId");
            return (Criteria) this;
        }

        public Criteria andCIdLessThanOrEqualTo(Integer value) {
            addCriterion("C_ID <=", value, "cId");
            return (Criteria) this;
        }

        public Criteria andCIdIn(List<Integer> values) {
            addCriterion("C_ID in", values, "cId");
            return (Criteria) this;
        }

        public Criteria andCIdNotIn(List<Integer> values) {
            addCriterion("C_ID not in", values, "cId");
            return (Criteria) this;
        }

        public Criteria andCIdBetween(Integer value1, Integer value2) {
            addCriterion("C_ID between", value1, value2, "cId");
            return (Criteria) this;
        }

        public Criteria andCIdNotBetween(Integer value1, Integer value2) {
            addCriterion("C_ID not between", value1, value2, "cId");
            return (Criteria) this;
        }

        public Criteria andIsNeedInvoiceIsNull() {
            addCriterion("IS_NEED_INVOICE is null");
            return (Criteria) this;
        }

        public Criteria andIsNeedInvoiceIsNotNull() {
            addCriterion("IS_NEED_INVOICE is not null");
            return (Criteria) this;
        }

        public Criteria andIsNeedInvoiceEqualTo(Integer value) {
            addCriterion("IS_NEED_INVOICE =", value, "isNeedInvoice");
            return (Criteria) this;
        }

        public Criteria andIsNeedInvoiceNotEqualTo(Integer value) {
            addCriterion("IS_NEED_INVOICE <>", value, "isNeedInvoice");
            return (Criteria) this;
        }

        public Criteria andIsNeedInvoiceGreaterThan(Integer value) {
            addCriterion("IS_NEED_INVOICE >", value, "isNeedInvoice");
            return (Criteria) this;
        }

        public Criteria andIsNeedInvoiceGreaterThanOrEqualTo(Integer value) {
            addCriterion("IS_NEED_INVOICE >=", value, "isNeedInvoice");
            return (Criteria) this;
        }

        public Criteria andIsNeedInvoiceLessThan(Integer value) {
            addCriterion("IS_NEED_INVOICE <", value, "isNeedInvoice");
            return (Criteria) this;
        }

        public Criteria andIsNeedInvoiceLessThanOrEqualTo(Integer value) {
            addCriterion("IS_NEED_INVOICE <=", value, "isNeedInvoice");
            return (Criteria) this;
        }

        public Criteria andIsNeedInvoiceIn(List<Integer> values) {
            addCriterion("IS_NEED_INVOICE in", values, "isNeedInvoice");
            return (Criteria) this;
        }

        public Criteria andIsNeedInvoiceNotIn(List<Integer> values) {
            addCriterion("IS_NEED_INVOICE not in", values, "isNeedInvoice");
            return (Criteria) this;
        }

        public Criteria andIsNeedInvoiceBetween(Integer value1, Integer value2) {
            addCriterion("IS_NEED_INVOICE between", value1, value2, "isNeedInvoice");
            return (Criteria) this;
        }

        public Criteria andIsNeedInvoiceNotBetween(Integer value1, Integer value2) {
            addCriterion("IS_NEED_INVOICE not between", value1, value2, "isNeedInvoice");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeIsNull() {
            addCriterion("INVOICE_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeIsNotNull() {
            addCriterion("INVOICE_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeEqualTo(Integer value) {
            addCriterion("INVOICE_TYPE =", value, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeNotEqualTo(Integer value) {
            addCriterion("INVOICE_TYPE <>", value, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeGreaterThan(Integer value) {
            addCriterion("INVOICE_TYPE >", value, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("INVOICE_TYPE >=", value, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeLessThan(Integer value) {
            addCriterion("INVOICE_TYPE <", value, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeLessThanOrEqualTo(Integer value) {
            addCriterion("INVOICE_TYPE <=", value, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeIn(List<Integer> values) {
            addCriterion("INVOICE_TYPE in", values, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeNotIn(List<Integer> values) {
            addCriterion("INVOICE_TYPE not in", values, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeBetween(Integer value1, Integer value2) {
            addCriterion("INVOICE_TYPE between", value1, value2, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("INVOICE_TYPE not between", value1, value2, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andPMethodIsNull() {
            addCriterion("P_METHOD is null");
            return (Criteria) this;
        }

        public Criteria andPMethodIsNotNull() {
            addCriterion("P_METHOD is not null");
            return (Criteria) this;
        }

        public Criteria andPMethodEqualTo(Integer value) {
            addCriterion("P_METHOD =", value, "pMethod");
            return (Criteria) this;
        }

        public Criteria andPMethodNotEqualTo(Integer value) {
            addCriterion("P_METHOD <>", value, "pMethod");
            return (Criteria) this;
        }

        public Criteria andPMethodGreaterThan(Integer value) {
            addCriterion("P_METHOD >", value, "pMethod");
            return (Criteria) this;
        }

        public Criteria andPMethodGreaterThanOrEqualTo(Integer value) {
            addCriterion("P_METHOD >=", value, "pMethod");
            return (Criteria) this;
        }

        public Criteria andPMethodLessThan(Integer value) {
            addCriterion("P_METHOD <", value, "pMethod");
            return (Criteria) this;
        }

        public Criteria andPMethodLessThanOrEqualTo(Integer value) {
            addCriterion("P_METHOD <=", value, "pMethod");
            return (Criteria) this;
        }

        public Criteria andPMethodIn(List<Integer> values) {
            addCriterion("P_METHOD in", values, "pMethod");
            return (Criteria) this;
        }

        public Criteria andPMethodNotIn(List<Integer> values) {
            addCriterion("P_METHOD not in", values, "pMethod");
            return (Criteria) this;
        }

        public Criteria andPMethodBetween(Integer value1, Integer value2) {
            addCriterion("P_METHOD between", value1, value2, "pMethod");
            return (Criteria) this;
        }

        public Criteria andPMethodNotBetween(Integer value1, Integer value2) {
            addCriterion("P_METHOD not between", value1, value2, "pMethod");
            return (Criteria) this;
        }

        public Criteria andPTypeIsNull() {
            addCriterion("P_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andPTypeIsNotNull() {
            addCriterion("P_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andPTypeEqualTo(Integer value) {
            addCriterion("P_TYPE =", value, "pType");
            return (Criteria) this;
        }

        public Criteria andPTypeNotEqualTo(Integer value) {
            addCriterion("P_TYPE <>", value, "pType");
            return (Criteria) this;
        }

        public Criteria andPTypeGreaterThan(Integer value) {
            addCriterion("P_TYPE >", value, "pType");
            return (Criteria) this;
        }

        public Criteria andPTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("P_TYPE >=", value, "pType");
            return (Criteria) this;
        }

        public Criteria andPTypeLessThan(Integer value) {
            addCriterion("P_TYPE <", value, "pType");
            return (Criteria) this;
        }

        public Criteria andPTypeLessThanOrEqualTo(Integer value) {
            addCriterion("P_TYPE <=", value, "pType");
            return (Criteria) this;
        }

        public Criteria andPTypeIn(List<Integer> values) {
            addCriterion("P_TYPE in", values, "pType");
            return (Criteria) this;
        }

        public Criteria andPTypeNotIn(List<Integer> values) {
            addCriterion("P_TYPE not in", values, "pType");
            return (Criteria) this;
        }

        public Criteria andPTypeBetween(Integer value1, Integer value2) {
            addCriterion("P_TYPE between", value1, value2, "pType");
            return (Criteria) this;
        }

        public Criteria andPTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("P_TYPE not between", value1, value2, "pType");
            return (Criteria) this;
        }

        public Criteria andPMoneyIsNull() {
            addCriterion("P_MONEY is null");
            return (Criteria) this;
        }

        public Criteria andPMoneyIsNotNull() {
            addCriterion("P_MONEY is not null");
            return (Criteria) this;
        }

        public Criteria andPMoneyEqualTo(Double value) {
            addCriterion("P_MONEY =", value, "pMoney");
            return (Criteria) this;
        }

        public Criteria andPMoneyNotEqualTo(Double value) {
            addCriterion("P_MONEY <>", value, "pMoney");
            return (Criteria) this;
        }

        public Criteria andPMoneyGreaterThan(Double value) {
            addCriterion("P_MONEY >", value, "pMoney");
            return (Criteria) this;
        }

        public Criteria andPMoneyGreaterThanOrEqualTo(Double value) {
            addCriterion("P_MONEY >=", value, "pMoney");
            return (Criteria) this;
        }

        public Criteria andPMoneyLessThan(Double value) {
            addCriterion("P_MONEY <", value, "pMoney");
            return (Criteria) this;
        }

        public Criteria andPMoneyLessThanOrEqualTo(Double value) {
            addCriterion("P_MONEY <=", value, "pMoney");
            return (Criteria) this;
        }

        public Criteria andPMoneyIn(List<Double> values) {
            addCriterion("P_MONEY in", values, "pMoney");
            return (Criteria) this;
        }

        public Criteria andPMoneyNotIn(List<Double> values) {
            addCriterion("P_MONEY not in", values, "pMoney");
            return (Criteria) this;
        }

        public Criteria andPMoneyBetween(Double value1, Double value2) {
            addCriterion("P_MONEY between", value1, value2, "pMoney");
            return (Criteria) this;
        }

        public Criteria andPMoneyNotBetween(Double value1, Double value2) {
            addCriterion("P_MONEY not between", value1, value2, "pMoney");
            return (Criteria) this;
        }

        public Criteria andPLevelIsNull() {
            addCriterion("P_LEVEL is null");
            return (Criteria) this;
        }

        public Criteria andPLevelIsNotNull() {
            addCriterion("P_LEVEL is not null");
            return (Criteria) this;
        }

        public Criteria andPLevelEqualTo(Integer value) {
            addCriterion("P_LEVEL =", value, "pLevel");
            return (Criteria) this;
        }

        public Criteria andPLevelNotEqualTo(Integer value) {
            addCriterion("P_LEVEL <>", value, "pLevel");
            return (Criteria) this;
        }

        public Criteria andPLevelGreaterThan(Integer value) {
            addCriterion("P_LEVEL >", value, "pLevel");
            return (Criteria) this;
        }

        public Criteria andPLevelGreaterThanOrEqualTo(Integer value) {
            addCriterion("P_LEVEL >=", value, "pLevel");
            return (Criteria) this;
        }

        public Criteria andPLevelLessThan(Integer value) {
            addCriterion("P_LEVEL <", value, "pLevel");
            return (Criteria) this;
        }

        public Criteria andPLevelLessThanOrEqualTo(Integer value) {
            addCriterion("P_LEVEL <=", value, "pLevel");
            return (Criteria) this;
        }

        public Criteria andPLevelIn(List<Integer> values) {
            addCriterion("P_LEVEL in", values, "pLevel");
            return (Criteria) this;
        }

        public Criteria andPLevelNotIn(List<Integer> values) {
            addCriterion("P_LEVEL not in", values, "pLevel");
            return (Criteria) this;
        }

        public Criteria andPLevelBetween(Integer value1, Integer value2) {
            addCriterion("P_LEVEL between", value1, value2, "pLevel");
            return (Criteria) this;
        }

        public Criteria andPLevelNotBetween(Integer value1, Integer value2) {
            addCriterion("P_LEVEL not between", value1, value2, "pLevel");
            return (Criteria) this;
        }

        public Criteria andJMethodIsNull() {
            addCriterion("J_METHOD is null");
            return (Criteria) this;
        }

        public Criteria andJMethodIsNotNull() {
            addCriterion("J_METHOD is not null");
            return (Criteria) this;
        }

        public Criteria andJMethodEqualTo(Integer value) {
            addCriterion("J_METHOD =", value, "jMethod");
            return (Criteria) this;
        }

        public Criteria andJMethodNotEqualTo(Integer value) {
            addCriterion("J_METHOD <>", value, "jMethod");
            return (Criteria) this;
        }

        public Criteria andJMethodGreaterThan(Integer value) {
            addCriterion("J_METHOD >", value, "jMethod");
            return (Criteria) this;
        }

        public Criteria andJMethodGreaterThanOrEqualTo(Integer value) {
            addCriterion("J_METHOD >=", value, "jMethod");
            return (Criteria) this;
        }

        public Criteria andJMethodLessThan(Integer value) {
            addCriterion("J_METHOD <", value, "jMethod");
            return (Criteria) this;
        }

        public Criteria andJMethodLessThanOrEqualTo(Integer value) {
            addCriterion("J_METHOD <=", value, "jMethod");
            return (Criteria) this;
        }

        public Criteria andJMethodIn(List<Integer> values) {
            addCriterion("J_METHOD in", values, "jMethod");
            return (Criteria) this;
        }

        public Criteria andJMethodNotIn(List<Integer> values) {
            addCriterion("J_METHOD not in", values, "jMethod");
            return (Criteria) this;
        }

        public Criteria andJMethodBetween(Integer value1, Integer value2) {
            addCriterion("J_METHOD between", value1, value2, "jMethod");
            return (Criteria) this;
        }

        public Criteria andJMethodNotBetween(Integer value1, Integer value2) {
            addCriterion("J_METHOD not between", value1, value2, "jMethod");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateIsNull() {
            addCriterion("DELIVERY_DATE is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateIsNotNull() {
            addCriterion("DELIVERY_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateEqualTo(Date value) {
            addCriterion("DELIVERY_DATE =", value, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateNotEqualTo(Date value) {
            addCriterion("DELIVERY_DATE <>", value, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateGreaterThan(Date value) {
            addCriterion("DELIVERY_DATE >", value, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateGreaterThanOrEqualTo(Date value) {
            addCriterion("DELIVERY_DATE >=", value, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateLessThan(Date value) {
            addCriterion("DELIVERY_DATE <", value, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateLessThanOrEqualTo(Date value) {
            addCriterion("DELIVERY_DATE <=", value, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateIn(List<Date> values) {
            addCriterion("DELIVERY_DATE in", values, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateNotIn(List<Date> values) {
            addCriterion("DELIVERY_DATE not in", values, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateBetween(Date value1, Date value2) {
            addCriterion("DELIVERY_DATE between", value1, value2, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateNotBetween(Date value1, Date value2) {
            addCriterion("DELIVERY_DATE not between", value1, value2, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andCommentsIsNull() {
            addCriterion("COMMENTS is null");
            return (Criteria) this;
        }

        public Criteria andCommentsIsNotNull() {
            addCriterion("COMMENTS is not null");
            return (Criteria) this;
        }

        public Criteria andCommentsEqualTo(String value) {
            addCriterion("COMMENTS =", value, "comments");
            return (Criteria) this;
        }

        public Criteria andCommentsNotEqualTo(String value) {
            addCriterion("COMMENTS <>", value, "comments");
            return (Criteria) this;
        }

        public Criteria andCommentsGreaterThan(String value) {
            addCriterion("COMMENTS >", value, "comments");
            return (Criteria) this;
        }

        public Criteria andCommentsGreaterThanOrEqualTo(String value) {
            addCriterion("COMMENTS >=", value, "comments");
            return (Criteria) this;
        }

        public Criteria andCommentsLessThan(String value) {
            addCriterion("COMMENTS <", value, "comments");
            return (Criteria) this;
        }

        public Criteria andCommentsLessThanOrEqualTo(String value) {
            addCriterion("COMMENTS <=", value, "comments");
            return (Criteria) this;
        }

        public Criteria andCommentsLike(String value) {
            addCriterion("COMMENTS like", value, "comments");
            return (Criteria) this;
        }

        public Criteria andCommentsNotLike(String value) {
            addCriterion("COMMENTS not like", value, "comments");
            return (Criteria) this;
        }

        public Criteria andCommentsIn(List<String> values) {
            addCriterion("COMMENTS in", values, "comments");
            return (Criteria) this;
        }

        public Criteria andCommentsNotIn(List<String> values) {
            addCriterion("COMMENTS not in", values, "comments");
            return (Criteria) this;
        }

        public Criteria andCommentsBetween(String value1, String value2) {
            addCriterion("COMMENTS between", value1, value2, "comments");
            return (Criteria) this;
        }

        public Criteria andCommentsNotBetween(String value1, String value2) {
            addCriterion("COMMENTS not between", value1, value2, "comments");
            return (Criteria) this;
        }

        public Criteria andIsStatusIsNull() {
            addCriterion("IS_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andIsStatusIsNotNull() {
            addCriterion("IS_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andIsStatusEqualTo(Integer value) {
            addCriterion("IS_STATUS =", value, "isStatus");
            return (Criteria) this;
        }

        public Criteria andIsStatusNotEqualTo(Integer value) {
            addCriterion("IS_STATUS <>", value, "isStatus");
            return (Criteria) this;
        }

        public Criteria andIsStatusGreaterThan(Integer value) {
            addCriterion("IS_STATUS >", value, "isStatus");
            return (Criteria) this;
        }

        public Criteria andIsStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("IS_STATUS >=", value, "isStatus");
            return (Criteria) this;
        }

        public Criteria andIsStatusLessThan(Integer value) {
            addCriterion("IS_STATUS <", value, "isStatus");
            return (Criteria) this;
        }

        public Criteria andIsStatusLessThanOrEqualTo(Integer value) {
            addCriterion("IS_STATUS <=", value, "isStatus");
            return (Criteria) this;
        }

        public Criteria andIsStatusIn(List<Integer> values) {
            addCriterion("IS_STATUS in", values, "isStatus");
            return (Criteria) this;
        }

        public Criteria andIsStatusNotIn(List<Integer> values) {
            addCriterion("IS_STATUS not in", values, "isStatus");
            return (Criteria) this;
        }

        public Criteria andIsStatusBetween(Integer value1, Integer value2) {
            addCriterion("IS_STATUS between", value1, value2, "isStatus");
            return (Criteria) this;
        }

        public Criteria andIsStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("IS_STATUS not between", value1, value2, "isStatus");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("STATUS is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("STATUS =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("STATUS <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("STATUS >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("STATUS >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("STATUS <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("STATUS <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("STATUS in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("STATUS not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("STATUS between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("STATUS not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andFStatusIsNull() {
            addCriterion("F_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andFStatusIsNotNull() {
            addCriterion("F_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andFStatusEqualTo(Integer value) {
            addCriterion("F_STATUS =", value, "fStatus");
            return (Criteria) this;
        }

        public Criteria andFStatusNotEqualTo(Integer value) {
            addCriterion("F_STATUS <>", value, "fStatus");
            return (Criteria) this;
        }

        public Criteria andFStatusGreaterThan(Integer value) {
            addCriterion("F_STATUS >", value, "fStatus");
            return (Criteria) this;
        }

        public Criteria andFStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_STATUS >=", value, "fStatus");
            return (Criteria) this;
        }

        public Criteria andFStatusLessThan(Integer value) {
            addCriterion("F_STATUS <", value, "fStatus");
            return (Criteria) this;
        }

        public Criteria andFStatusLessThanOrEqualTo(Integer value) {
            addCriterion("F_STATUS <=", value, "fStatus");
            return (Criteria) this;
        }

        public Criteria andFStatusIn(List<Integer> values) {
            addCriterion("F_STATUS in", values, "fStatus");
            return (Criteria) this;
        }

        public Criteria andFStatusNotIn(List<Integer> values) {
            addCriterion("F_STATUS not in", values, "fStatus");
            return (Criteria) this;
        }

        public Criteria andFStatusBetween(Integer value1, Integer value2) {
            addCriterion("F_STATUS between", value1, value2, "fStatus");
            return (Criteria) this;
        }

        public Criteria andFStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("F_STATUS not between", value1, value2, "fStatus");
            return (Criteria) this;
        }

        public Criteria andIsTimeIsNull() {
            addCriterion("IS_TIME is null");
            return (Criteria) this;
        }

        public Criteria andIsTimeIsNotNull() {
            addCriterion("IS_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andIsTimeEqualTo(Date value) {
            addCriterion("IS_TIME =", value, "isTime");
            return (Criteria) this;
        }

        public Criteria andIsTimeNotEqualTo(Date value) {
            addCriterion("IS_TIME <>", value, "isTime");
            return (Criteria) this;
        }

        public Criteria andIsTimeGreaterThan(Date value) {
            addCriterion("IS_TIME >", value, "isTime");
            return (Criteria) this;
        }

        public Criteria andIsTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("IS_TIME >=", value, "isTime");
            return (Criteria) this;
        }

        public Criteria andIsTimeLessThan(Date value) {
            addCriterion("IS_TIME <", value, "isTime");
            return (Criteria) this;
        }

        public Criteria andIsTimeLessThanOrEqualTo(Date value) {
            addCriterion("IS_TIME <=", value, "isTime");
            return (Criteria) this;
        }

        public Criteria andIsTimeIn(List<Date> values) {
            addCriterion("IS_TIME in", values, "isTime");
            return (Criteria) this;
        }

        public Criteria andIsTimeNotIn(List<Date> values) {
            addCriterion("IS_TIME not in", values, "isTime");
            return (Criteria) this;
        }

        public Criteria andIsTimeBetween(Date value1, Date value2) {
            addCriterion("IS_TIME between", value1, value2, "isTime");
            return (Criteria) this;
        }

        public Criteria andIsTimeNotBetween(Date value1, Date value2) {
            addCriterion("IS_TIME not between", value1, value2, "isTime");
            return (Criteria) this;
        }

        public Criteria andIsAuthorIsNull() {
            addCriterion("IS_AUTHOR is null");
            return (Criteria) this;
        }

        public Criteria andIsAuthorIsNotNull() {
            addCriterion("IS_AUTHOR is not null");
            return (Criteria) this;
        }

        public Criteria andIsAuthorEqualTo(String value) {
            addCriterion("IS_AUTHOR =", value, "isAuthor");
            return (Criteria) this;
        }

        public Criteria andIsAuthorNotEqualTo(String value) {
            addCriterion("IS_AUTHOR <>", value, "isAuthor");
            return (Criteria) this;
        }

        public Criteria andIsAuthorGreaterThan(String value) {
            addCriterion("IS_AUTHOR >", value, "isAuthor");
            return (Criteria) this;
        }

        public Criteria andIsAuthorGreaterThanOrEqualTo(String value) {
            addCriterion("IS_AUTHOR >=", value, "isAuthor");
            return (Criteria) this;
        }

        public Criteria andIsAuthorLessThan(String value) {
            addCriterion("IS_AUTHOR <", value, "isAuthor");
            return (Criteria) this;
        }

        public Criteria andIsAuthorLessThanOrEqualTo(String value) {
            addCriterion("IS_AUTHOR <=", value, "isAuthor");
            return (Criteria) this;
        }

        public Criteria andIsAuthorLike(String value) {
            addCriterion("IS_AUTHOR like", value, "isAuthor");
            return (Criteria) this;
        }

        public Criteria andIsAuthorNotLike(String value) {
            addCriterion("IS_AUTHOR not like", value, "isAuthor");
            return (Criteria) this;
        }

        public Criteria andIsAuthorIn(List<String> values) {
            addCriterion("IS_AUTHOR in", values, "isAuthor");
            return (Criteria) this;
        }

        public Criteria andIsAuthorNotIn(List<String> values) {
            addCriterion("IS_AUTHOR not in", values, "isAuthor");
            return (Criteria) this;
        }

        public Criteria andIsAuthorBetween(String value1, String value2) {
            addCriterion("IS_AUTHOR between", value1, value2, "isAuthor");
            return (Criteria) this;
        }

        public Criteria andIsAuthorNotBetween(String value1, String value2) {
            addCriterion("IS_AUTHOR not between", value1, value2, "isAuthor");
            return (Criteria) this;
        }

        public Criteria andIsReTimeIsNull() {
            addCriterion("IS_RE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andIsReTimeIsNotNull() {
            addCriterion("IS_RE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andIsReTimeEqualTo(Date value) {
            addCriterion("IS_RE_TIME =", value, "isReTime");
            return (Criteria) this;
        }

        public Criteria andIsReTimeNotEqualTo(Date value) {
            addCriterion("IS_RE_TIME <>", value, "isReTime");
            return (Criteria) this;
        }

        public Criteria andIsReTimeGreaterThan(Date value) {
            addCriterion("IS_RE_TIME >", value, "isReTime");
            return (Criteria) this;
        }

        public Criteria andIsReTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("IS_RE_TIME >=", value, "isReTime");
            return (Criteria) this;
        }

        public Criteria andIsReTimeLessThan(Date value) {
            addCriterion("IS_RE_TIME <", value, "isReTime");
            return (Criteria) this;
        }

        public Criteria andIsReTimeLessThanOrEqualTo(Date value) {
            addCriterion("IS_RE_TIME <=", value, "isReTime");
            return (Criteria) this;
        }

        public Criteria andIsReTimeIn(List<Date> values) {
            addCriterion("IS_RE_TIME in", values, "isReTime");
            return (Criteria) this;
        }

        public Criteria andIsReTimeNotIn(List<Date> values) {
            addCriterion("IS_RE_TIME not in", values, "isReTime");
            return (Criteria) this;
        }

        public Criteria andIsReTimeBetween(Date value1, Date value2) {
            addCriterion("IS_RE_TIME between", value1, value2, "isReTime");
            return (Criteria) this;
        }

        public Criteria andIsReTimeNotBetween(Date value1, Date value2) {
            addCriterion("IS_RE_TIME not between", value1, value2, "isReTime");
            return (Criteria) this;
        }

        public Criteria andIsReAuthorIsNull() {
            addCriterion("IS_RE_AUTHOR is null");
            return (Criteria) this;
        }

        public Criteria andIsReAuthorIsNotNull() {
            addCriterion("IS_RE_AUTHOR is not null");
            return (Criteria) this;
        }

        public Criteria andIsReAuthorEqualTo(String value) {
            addCriterion("IS_RE_AUTHOR =", value, "isReAuthor");
            return (Criteria) this;
        }

        public Criteria andIsReAuthorNotEqualTo(String value) {
            addCriterion("IS_RE_AUTHOR <>", value, "isReAuthor");
            return (Criteria) this;
        }

        public Criteria andIsReAuthorGreaterThan(String value) {
            addCriterion("IS_RE_AUTHOR >", value, "isReAuthor");
            return (Criteria) this;
        }

        public Criteria andIsReAuthorGreaterThanOrEqualTo(String value) {
            addCriterion("IS_RE_AUTHOR >=", value, "isReAuthor");
            return (Criteria) this;
        }

        public Criteria andIsReAuthorLessThan(String value) {
            addCriterion("IS_RE_AUTHOR <", value, "isReAuthor");
            return (Criteria) this;
        }

        public Criteria andIsReAuthorLessThanOrEqualTo(String value) {
            addCriterion("IS_RE_AUTHOR <=", value, "isReAuthor");
            return (Criteria) this;
        }

        public Criteria andIsReAuthorLike(String value) {
            addCriterion("IS_RE_AUTHOR like", value, "isReAuthor");
            return (Criteria) this;
        }

        public Criteria andIsReAuthorNotLike(String value) {
            addCriterion("IS_RE_AUTHOR not like", value, "isReAuthor");
            return (Criteria) this;
        }

        public Criteria andIsReAuthorIn(List<String> values) {
            addCriterion("IS_RE_AUTHOR in", values, "isReAuthor");
            return (Criteria) this;
        }

        public Criteria andIsReAuthorNotIn(List<String> values) {
            addCriterion("IS_RE_AUTHOR not in", values, "isReAuthor");
            return (Criteria) this;
        }

        public Criteria andIsReAuthorBetween(String value1, String value2) {
            addCriterion("IS_RE_AUTHOR between", value1, value2, "isReAuthor");
            return (Criteria) this;
        }

        public Criteria andIsReAuthorNotBetween(String value1, String value2) {
            addCriterion("IS_RE_AUTHOR not between", value1, value2, "isReAuthor");
            return (Criteria) this;
        }

        public Criteria andOIndateIsNull() {
            addCriterion("O_INDATE is null");
            return (Criteria) this;
        }

        public Criteria andOIndateIsNotNull() {
            addCriterion("O_INDATE is not null");
            return (Criteria) this;
        }

        public Criteria andOIndateEqualTo(Date value) {
            addCriterion("O_INDATE =", value, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOIndateNotEqualTo(Date value) {
            addCriterion("O_INDATE <>", value, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOIndateGreaterThan(Date value) {
            addCriterion("O_INDATE >", value, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOIndateGreaterThanOrEqualTo(Date value) {
            addCriterion("O_INDATE >=", value, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOIndateLessThan(Date value) {
            addCriterion("O_INDATE <", value, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOIndateLessThanOrEqualTo(Date value) {
            addCriterion("O_INDATE <=", value, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOIndateIn(List<Date> values) {
            addCriterion("O_INDATE in", values, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOIndateNotIn(List<Date> values) {
            addCriterion("O_INDATE not in", values, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOIndateBetween(Date value1, Date value2) {
            addCriterion("O_INDATE between", value1, value2, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOIndateNotBetween(Date value1, Date value2) {
            addCriterion("O_INDATE not between", value1, value2, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOInAuthorIsNull() {
            addCriterion("O_IN_AUTHOR is null");
            return (Criteria) this;
        }

        public Criteria andOInAuthorIsNotNull() {
            addCriterion("O_IN_AUTHOR is not null");
            return (Criteria) this;
        }

        public Criteria andOInAuthorEqualTo(String value) {
            addCriterion("O_IN_AUTHOR =", value, "oInAuthor");
            return (Criteria) this;
        }

        public Criteria andOInAuthorNotEqualTo(String value) {
            addCriterion("O_IN_AUTHOR <>", value, "oInAuthor");
            return (Criteria) this;
        }

        public Criteria andOInAuthorGreaterThan(String value) {
            addCriterion("O_IN_AUTHOR >", value, "oInAuthor");
            return (Criteria) this;
        }

        public Criteria andOInAuthorGreaterThanOrEqualTo(String value) {
            addCriterion("O_IN_AUTHOR >=", value, "oInAuthor");
            return (Criteria) this;
        }

        public Criteria andOInAuthorLessThan(String value) {
            addCriterion("O_IN_AUTHOR <", value, "oInAuthor");
            return (Criteria) this;
        }

        public Criteria andOInAuthorLessThanOrEqualTo(String value) {
            addCriterion("O_IN_AUTHOR <=", value, "oInAuthor");
            return (Criteria) this;
        }

        public Criteria andOInAuthorLike(String value) {
            addCriterion("O_IN_AUTHOR like", value, "oInAuthor");
            return (Criteria) this;
        }

        public Criteria andOInAuthorNotLike(String value) {
            addCriterion("O_IN_AUTHOR not like", value, "oInAuthor");
            return (Criteria) this;
        }

        public Criteria andOInAuthorIn(List<String> values) {
            addCriterion("O_IN_AUTHOR in", values, "oInAuthor");
            return (Criteria) this;
        }

        public Criteria andOInAuthorNotIn(List<String> values) {
            addCriterion("O_IN_AUTHOR not in", values, "oInAuthor");
            return (Criteria) this;
        }

        public Criteria andOInAuthorBetween(String value1, String value2) {
            addCriterion("O_IN_AUTHOR between", value1, value2, "oInAuthor");
            return (Criteria) this;
        }

        public Criteria andOInAuthorNotBetween(String value1, String value2) {
            addCriterion("O_IN_AUTHOR not between", value1, value2, "oInAuthor");
            return (Criteria) this;
        }

        public Criteria andOOneAuditTimeIsNull() {
            addCriterion("O_ONE_AUDIT_TIME is null");
            return (Criteria) this;
        }

        public Criteria andOOneAuditTimeIsNotNull() {
            addCriterion("O_ONE_AUDIT_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andOOneAuditTimeEqualTo(Date value) {
            addCriterion("O_ONE_AUDIT_TIME =", value, "oOneAuditTime");
            return (Criteria) this;
        }

        public Criteria andOOneAuditTimeNotEqualTo(Date value) {
            addCriterion("O_ONE_AUDIT_TIME <>", value, "oOneAuditTime");
            return (Criteria) this;
        }

        public Criteria andOOneAuditTimeGreaterThan(Date value) {
            addCriterion("O_ONE_AUDIT_TIME >", value, "oOneAuditTime");
            return (Criteria) this;
        }

        public Criteria andOOneAuditTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("O_ONE_AUDIT_TIME >=", value, "oOneAuditTime");
            return (Criteria) this;
        }

        public Criteria andOOneAuditTimeLessThan(Date value) {
            addCriterion("O_ONE_AUDIT_TIME <", value, "oOneAuditTime");
            return (Criteria) this;
        }

        public Criteria andOOneAuditTimeLessThanOrEqualTo(Date value) {
            addCriterion("O_ONE_AUDIT_TIME <=", value, "oOneAuditTime");
            return (Criteria) this;
        }

        public Criteria andOOneAuditTimeIn(List<Date> values) {
            addCriterion("O_ONE_AUDIT_TIME in", values, "oOneAuditTime");
            return (Criteria) this;
        }

        public Criteria andOOneAuditTimeNotIn(List<Date> values) {
            addCriterion("O_ONE_AUDIT_TIME not in", values, "oOneAuditTime");
            return (Criteria) this;
        }

        public Criteria andOOneAuditTimeBetween(Date value1, Date value2) {
            addCriterion("O_ONE_AUDIT_TIME between", value1, value2, "oOneAuditTime");
            return (Criteria) this;
        }

        public Criteria andOOneAuditTimeNotBetween(Date value1, Date value2) {
            addCriterion("O_ONE_AUDIT_TIME not between", value1, value2, "oOneAuditTime");
            return (Criteria) this;
        }

        public Criteria andOOneAuditAuthorIsNull() {
            addCriterion("O_ONE_AUDIT_AUTHOR is null");
            return (Criteria) this;
        }

        public Criteria andOOneAuditAuthorIsNotNull() {
            addCriterion("O_ONE_AUDIT_AUTHOR is not null");
            return (Criteria) this;
        }

        public Criteria andOOneAuditAuthorEqualTo(String value) {
            addCriterion("O_ONE_AUDIT_AUTHOR =", value, "oOneAuditAuthor");
            return (Criteria) this;
        }

        public Criteria andOOneAuditAuthorNotEqualTo(String value) {
            addCriterion("O_ONE_AUDIT_AUTHOR <>", value, "oOneAuditAuthor");
            return (Criteria) this;
        }

        public Criteria andOOneAuditAuthorGreaterThan(String value) {
            addCriterion("O_ONE_AUDIT_AUTHOR >", value, "oOneAuditAuthor");
            return (Criteria) this;
        }

        public Criteria andOOneAuditAuthorGreaterThanOrEqualTo(String value) {
            addCriterion("O_ONE_AUDIT_AUTHOR >=", value, "oOneAuditAuthor");
            return (Criteria) this;
        }

        public Criteria andOOneAuditAuthorLessThan(String value) {
            addCriterion("O_ONE_AUDIT_AUTHOR <", value, "oOneAuditAuthor");
            return (Criteria) this;
        }

        public Criteria andOOneAuditAuthorLessThanOrEqualTo(String value) {
            addCriterion("O_ONE_AUDIT_AUTHOR <=", value, "oOneAuditAuthor");
            return (Criteria) this;
        }

        public Criteria andOOneAuditAuthorLike(String value) {
            addCriterion("O_ONE_AUDIT_AUTHOR like", value, "oOneAuditAuthor");
            return (Criteria) this;
        }

        public Criteria andOOneAuditAuthorNotLike(String value) {
            addCriterion("O_ONE_AUDIT_AUTHOR not like", value, "oOneAuditAuthor");
            return (Criteria) this;
        }

        public Criteria andOOneAuditAuthorIn(List<String> values) {
            addCriterion("O_ONE_AUDIT_AUTHOR in", values, "oOneAuditAuthor");
            return (Criteria) this;
        }

        public Criteria andOOneAuditAuthorNotIn(List<String> values) {
            addCriterion("O_ONE_AUDIT_AUTHOR not in", values, "oOneAuditAuthor");
            return (Criteria) this;
        }

        public Criteria andOOneAuditAuthorBetween(String value1, String value2) {
            addCriterion("O_ONE_AUDIT_AUTHOR between", value1, value2, "oOneAuditAuthor");
            return (Criteria) this;
        }

        public Criteria andOOneAuditAuthorNotBetween(String value1, String value2) {
            addCriterion("O_ONE_AUDIT_AUTHOR not between", value1, value2, "oOneAuditAuthor");
            return (Criteria) this;
        }

        public Criteria andOTwoAuditTimeIsNull() {
            addCriterion("O_TWO_AUDIT_TIME is null");
            return (Criteria) this;
        }

        public Criteria andOTwoAuditTimeIsNotNull() {
            addCriterion("O_TWO_AUDIT_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andOTwoAuditTimeEqualTo(Date value) {
            addCriterion("O_TWO_AUDIT_TIME =", value, "oTwoAuditTime");
            return (Criteria) this;
        }

        public Criteria andOTwoAuditTimeNotEqualTo(Date value) {
            addCriterion("O_TWO_AUDIT_TIME <>", value, "oTwoAuditTime");
            return (Criteria) this;
        }

        public Criteria andOTwoAuditTimeGreaterThan(Date value) {
            addCriterion("O_TWO_AUDIT_TIME >", value, "oTwoAuditTime");
            return (Criteria) this;
        }

        public Criteria andOTwoAuditTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("O_TWO_AUDIT_TIME >=", value, "oTwoAuditTime");
            return (Criteria) this;
        }

        public Criteria andOTwoAuditTimeLessThan(Date value) {
            addCriterion("O_TWO_AUDIT_TIME <", value, "oTwoAuditTime");
            return (Criteria) this;
        }

        public Criteria andOTwoAuditTimeLessThanOrEqualTo(Date value) {
            addCriterion("O_TWO_AUDIT_TIME <=", value, "oTwoAuditTime");
            return (Criteria) this;
        }

        public Criteria andOTwoAuditTimeIn(List<Date> values) {
            addCriterion("O_TWO_AUDIT_TIME in", values, "oTwoAuditTime");
            return (Criteria) this;
        }

        public Criteria andOTwoAuditTimeNotIn(List<Date> values) {
            addCriterion("O_TWO_AUDIT_TIME not in", values, "oTwoAuditTime");
            return (Criteria) this;
        }

        public Criteria andOTwoAuditTimeBetween(Date value1, Date value2) {
            addCriterion("O_TWO_AUDIT_TIME between", value1, value2, "oTwoAuditTime");
            return (Criteria) this;
        }

        public Criteria andOTwoAuditTimeNotBetween(Date value1, Date value2) {
            addCriterion("O_TWO_AUDIT_TIME not between", value1, value2, "oTwoAuditTime");
            return (Criteria) this;
        }

        public Criteria andOTwoAuditAuthorIsNull() {
            addCriterion("O_TWO_AUDIT_AUTHOR is null");
            return (Criteria) this;
        }

        public Criteria andOTwoAuditAuthorIsNotNull() {
            addCriterion("O_TWO_AUDIT_AUTHOR is not null");
            return (Criteria) this;
        }

        public Criteria andOTwoAuditAuthorEqualTo(String value) {
            addCriterion("O_TWO_AUDIT_AUTHOR =", value, "oTwoAuditAuthor");
            return (Criteria) this;
        }

        public Criteria andOTwoAuditAuthorNotEqualTo(String value) {
            addCriterion("O_TWO_AUDIT_AUTHOR <>", value, "oTwoAuditAuthor");
            return (Criteria) this;
        }

        public Criteria andOTwoAuditAuthorGreaterThan(String value) {
            addCriterion("O_TWO_AUDIT_AUTHOR >", value, "oTwoAuditAuthor");
            return (Criteria) this;
        }

        public Criteria andOTwoAuditAuthorGreaterThanOrEqualTo(String value) {
            addCriterion("O_TWO_AUDIT_AUTHOR >=", value, "oTwoAuditAuthor");
            return (Criteria) this;
        }

        public Criteria andOTwoAuditAuthorLessThan(String value) {
            addCriterion("O_TWO_AUDIT_AUTHOR <", value, "oTwoAuditAuthor");
            return (Criteria) this;
        }

        public Criteria andOTwoAuditAuthorLessThanOrEqualTo(String value) {
            addCriterion("O_TWO_AUDIT_AUTHOR <=", value, "oTwoAuditAuthor");
            return (Criteria) this;
        }

        public Criteria andOTwoAuditAuthorLike(String value) {
            addCriterion("O_TWO_AUDIT_AUTHOR like", value, "oTwoAuditAuthor");
            return (Criteria) this;
        }

        public Criteria andOTwoAuditAuthorNotLike(String value) {
            addCriterion("O_TWO_AUDIT_AUTHOR not like", value, "oTwoAuditAuthor");
            return (Criteria) this;
        }

        public Criteria andOTwoAuditAuthorIn(List<String> values) {
            addCriterion("O_TWO_AUDIT_AUTHOR in", values, "oTwoAuditAuthor");
            return (Criteria) this;
        }

        public Criteria andOTwoAuditAuthorNotIn(List<String> values) {
            addCriterion("O_TWO_AUDIT_AUTHOR not in", values, "oTwoAuditAuthor");
            return (Criteria) this;
        }

        public Criteria andOTwoAuditAuthorBetween(String value1, String value2) {
            addCriterion("O_TWO_AUDIT_AUTHOR between", value1, value2, "oTwoAuditAuthor");
            return (Criteria) this;
        }

        public Criteria andOTwoAuditAuthorNotBetween(String value1, String value2) {
            addCriterion("O_TWO_AUDIT_AUTHOR not between", value1, value2, "oTwoAuditAuthor");
            return (Criteria) this;
        }

        public Criteria andOAuditReTimeIsNull() {
            addCriterion("O_AUDIT_RE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andOAuditReTimeIsNotNull() {
            addCriterion("O_AUDIT_RE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andOAuditReTimeEqualTo(Date value) {
            addCriterion("O_AUDIT_RE_TIME =", value, "oAuditReTime");
            return (Criteria) this;
        }

        public Criteria andOAuditReTimeNotEqualTo(Date value) {
            addCriterion("O_AUDIT_RE_TIME <>", value, "oAuditReTime");
            return (Criteria) this;
        }

        public Criteria andOAuditReTimeGreaterThan(Date value) {
            addCriterion("O_AUDIT_RE_TIME >", value, "oAuditReTime");
            return (Criteria) this;
        }

        public Criteria andOAuditReTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("O_AUDIT_RE_TIME >=", value, "oAuditReTime");
            return (Criteria) this;
        }

        public Criteria andOAuditReTimeLessThan(Date value) {
            addCriterion("O_AUDIT_RE_TIME <", value, "oAuditReTime");
            return (Criteria) this;
        }

        public Criteria andOAuditReTimeLessThanOrEqualTo(Date value) {
            addCriterion("O_AUDIT_RE_TIME <=", value, "oAuditReTime");
            return (Criteria) this;
        }

        public Criteria andOAuditReTimeIn(List<Date> values) {
            addCriterion("O_AUDIT_RE_TIME in", values, "oAuditReTime");
            return (Criteria) this;
        }

        public Criteria andOAuditReTimeNotIn(List<Date> values) {
            addCriterion("O_AUDIT_RE_TIME not in", values, "oAuditReTime");
            return (Criteria) this;
        }

        public Criteria andOAuditReTimeBetween(Date value1, Date value2) {
            addCriterion("O_AUDIT_RE_TIME between", value1, value2, "oAuditReTime");
            return (Criteria) this;
        }

        public Criteria andOAuditReTimeNotBetween(Date value1, Date value2) {
            addCriterion("O_AUDIT_RE_TIME not between", value1, value2, "oAuditReTime");
            return (Criteria) this;
        }

        public Criteria andOAuditReAuthorIsNull() {
            addCriterion("O_AUDIT_RE_AUTHOR is null");
            return (Criteria) this;
        }

        public Criteria andOAuditReAuthorIsNotNull() {
            addCriterion("O_AUDIT_RE_AUTHOR is not null");
            return (Criteria) this;
        }

        public Criteria andOAuditReAuthorEqualTo(String value) {
            addCriterion("O_AUDIT_RE_AUTHOR =", value, "oAuditReAuthor");
            return (Criteria) this;
        }

        public Criteria andOAuditReAuthorNotEqualTo(String value) {
            addCriterion("O_AUDIT_RE_AUTHOR <>", value, "oAuditReAuthor");
            return (Criteria) this;
        }

        public Criteria andOAuditReAuthorGreaterThan(String value) {
            addCriterion("O_AUDIT_RE_AUTHOR >", value, "oAuditReAuthor");
            return (Criteria) this;
        }

        public Criteria andOAuditReAuthorGreaterThanOrEqualTo(String value) {
            addCriterion("O_AUDIT_RE_AUTHOR >=", value, "oAuditReAuthor");
            return (Criteria) this;
        }

        public Criteria andOAuditReAuthorLessThan(String value) {
            addCriterion("O_AUDIT_RE_AUTHOR <", value, "oAuditReAuthor");
            return (Criteria) this;
        }

        public Criteria andOAuditReAuthorLessThanOrEqualTo(String value) {
            addCriterion("O_AUDIT_RE_AUTHOR <=", value, "oAuditReAuthor");
            return (Criteria) this;
        }

        public Criteria andOAuditReAuthorLike(String value) {
            addCriterion("O_AUDIT_RE_AUTHOR like", value, "oAuditReAuthor");
            return (Criteria) this;
        }

        public Criteria andOAuditReAuthorNotLike(String value) {
            addCriterion("O_AUDIT_RE_AUTHOR not like", value, "oAuditReAuthor");
            return (Criteria) this;
        }

        public Criteria andOAuditReAuthorIn(List<String> values) {
            addCriterion("O_AUDIT_RE_AUTHOR in", values, "oAuditReAuthor");
            return (Criteria) this;
        }

        public Criteria andOAuditReAuthorNotIn(List<String> values) {
            addCriterion("O_AUDIT_RE_AUTHOR not in", values, "oAuditReAuthor");
            return (Criteria) this;
        }

        public Criteria andOAuditReAuthorBetween(String value1, String value2) {
            addCriterion("O_AUDIT_RE_AUTHOR between", value1, value2, "oAuditReAuthor");
            return (Criteria) this;
        }

        public Criteria andOAuditReAuthorNotBetween(String value1, String value2) {
            addCriterion("O_AUDIT_RE_AUTHOR not between", value1, value2, "oAuditReAuthor");
            return (Criteria) this;
        }

        public Criteria andFTimeIsNull() {
            addCriterion("F_TIME is null");
            return (Criteria) this;
        }

        public Criteria andFTimeIsNotNull() {
            addCriterion("F_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andFTimeEqualTo(Date value) {
            addCriterion("F_TIME =", value, "fTime");
            return (Criteria) this;
        }

        public Criteria andFTimeNotEqualTo(Date value) {
            addCriterion("F_TIME <>", value, "fTime");
            return (Criteria) this;
        }

        public Criteria andFTimeGreaterThan(Date value) {
            addCriterion("F_TIME >", value, "fTime");
            return (Criteria) this;
        }

        public Criteria andFTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("F_TIME >=", value, "fTime");
            return (Criteria) this;
        }

        public Criteria andFTimeLessThan(Date value) {
            addCriterion("F_TIME <", value, "fTime");
            return (Criteria) this;
        }

        public Criteria andFTimeLessThanOrEqualTo(Date value) {
            addCriterion("F_TIME <=", value, "fTime");
            return (Criteria) this;
        }

        public Criteria andFTimeIn(List<Date> values) {
            addCriterion("F_TIME in", values, "fTime");
            return (Criteria) this;
        }

        public Criteria andFTimeNotIn(List<Date> values) {
            addCriterion("F_TIME not in", values, "fTime");
            return (Criteria) this;
        }

        public Criteria andFTimeBetween(Date value1, Date value2) {
            addCriterion("F_TIME between", value1, value2, "fTime");
            return (Criteria) this;
        }

        public Criteria andFTimeNotBetween(Date value1, Date value2) {
            addCriterion("F_TIME not between", value1, value2, "fTime");
            return (Criteria) this;
        }

        public Criteria andFAuthorIsNull() {
            addCriterion("F_AUTHOR is null");
            return (Criteria) this;
        }

        public Criteria andFAuthorIsNotNull() {
            addCriterion("F_AUTHOR is not null");
            return (Criteria) this;
        }

        public Criteria andFAuthorEqualTo(String value) {
            addCriterion("F_AUTHOR =", value, "fAuthor");
            return (Criteria) this;
        }

        public Criteria andFAuthorNotEqualTo(String value) {
            addCriterion("F_AUTHOR <>", value, "fAuthor");
            return (Criteria) this;
        }

        public Criteria andFAuthorGreaterThan(String value) {
            addCriterion("F_AUTHOR >", value, "fAuthor");
            return (Criteria) this;
        }

        public Criteria andFAuthorGreaterThanOrEqualTo(String value) {
            addCriterion("F_AUTHOR >=", value, "fAuthor");
            return (Criteria) this;
        }

        public Criteria andFAuthorLessThan(String value) {
            addCriterion("F_AUTHOR <", value, "fAuthor");
            return (Criteria) this;
        }

        public Criteria andFAuthorLessThanOrEqualTo(String value) {
            addCriterion("F_AUTHOR <=", value, "fAuthor");
            return (Criteria) this;
        }

        public Criteria andFAuthorLike(String value) {
            addCriterion("F_AUTHOR like", value, "fAuthor");
            return (Criteria) this;
        }

        public Criteria andFAuthorNotLike(String value) {
            addCriterion("F_AUTHOR not like", value, "fAuthor");
            return (Criteria) this;
        }

        public Criteria andFAuthorIn(List<String> values) {
            addCriterion("F_AUTHOR in", values, "fAuthor");
            return (Criteria) this;
        }

        public Criteria andFAuthorNotIn(List<String> values) {
            addCriterion("F_AUTHOR not in", values, "fAuthor");
            return (Criteria) this;
        }

        public Criteria andFAuthorBetween(String value1, String value2) {
            addCriterion("F_AUTHOR between", value1, value2, "fAuthor");
            return (Criteria) this;
        }

        public Criteria andFAuthorNotBetween(String value1, String value2) {
            addCriterion("F_AUTHOR not between", value1, value2, "fAuthor");
            return (Criteria) this;
        }

        public Criteria andCextIdIsNull() {
            addCriterion("CEXT_ID is null");
            return (Criteria) this;
        }

        public Criteria andCextIdIsNotNull() {
            addCriterion("CEXT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andCextIdEqualTo(Integer value) {
            addCriterion("CEXT_ID =", value, "cextId");
            return (Criteria) this;
        }

        public Criteria andCextIdNotEqualTo(Integer value) {
            addCriterion("CEXT_ID <>", value, "cextId");
            return (Criteria) this;
        }

        public Criteria andCextIdGreaterThan(Integer value) {
            addCriterion("CEXT_ID >", value, "cextId");
            return (Criteria) this;
        }

        public Criteria andCextIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("CEXT_ID >=", value, "cextId");
            return (Criteria) this;
        }

        public Criteria andCextIdLessThan(Integer value) {
            addCriterion("CEXT_ID <", value, "cextId");
            return (Criteria) this;
        }

        public Criteria andCextIdLessThanOrEqualTo(Integer value) {
            addCriterion("CEXT_ID <=", value, "cextId");
            return (Criteria) this;
        }

        public Criteria andCextIdIn(List<Integer> values) {
            addCriterion("CEXT_ID in", values, "cextId");
            return (Criteria) this;
        }

        public Criteria andCextIdNotIn(List<Integer> values) {
            addCriterion("CEXT_ID not in", values, "cextId");
            return (Criteria) this;
        }

        public Criteria andCextIdBetween(Integer value1, Integer value2) {
            addCriterion("CEXT_ID between", value1, value2, "cextId");
            return (Criteria) this;
        }

        public Criteria andCextIdNotBetween(Integer value1, Integer value2) {
            addCriterion("CEXT_ID not between", value1, value2, "cextId");
            return (Criteria) this;
        }

        public Criteria andCphoneIsNull() {
            addCriterion("CPHONE is null");
            return (Criteria) this;
        }

        public Criteria andCphoneIsNotNull() {
            addCriterion("CPHONE is not null");
            return (Criteria) this;
        }

        public Criteria andCphoneEqualTo(String value) {
            addCriterion("CPHONE =", value, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneNotEqualTo(String value) {
            addCriterion("CPHONE <>", value, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneGreaterThan(String value) {
            addCriterion("CPHONE >", value, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneGreaterThanOrEqualTo(String value) {
            addCriterion("CPHONE >=", value, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneLessThan(String value) {
            addCriterion("CPHONE <", value, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneLessThanOrEqualTo(String value) {
            addCriterion("CPHONE <=", value, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneLike(String value) {
            addCriterion("CPHONE like", value, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneNotLike(String value) {
            addCriterion("CPHONE not like", value, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneIn(List<String> values) {
            addCriterion("CPHONE in", values, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneNotIn(List<String> values) {
            addCriterion("CPHONE not in", values, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneBetween(String value1, String value2) {
            addCriterion("CPHONE between", value1, value2, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneNotBetween(String value1, String value2) {
            addCriterion("CPHONE not between", value1, value2, "cphone");
            return (Criteria) this;
        }

        public Criteria andCpersonIsNull() {
            addCriterion("CPERSON is null");
            return (Criteria) this;
        }

        public Criteria andCpersonIsNotNull() {
            addCriterion("CPERSON is not null");
            return (Criteria) this;
        }

        public Criteria andCpersonEqualTo(String value) {
            addCriterion("CPERSON =", value, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonNotEqualTo(String value) {
            addCriterion("CPERSON <>", value, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonGreaterThan(String value) {
            addCriterion("CPERSON >", value, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonGreaterThanOrEqualTo(String value) {
            addCriterion("CPERSON >=", value, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonLessThan(String value) {
            addCriterion("CPERSON <", value, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonLessThanOrEqualTo(String value) {
            addCriterion("CPERSON <=", value, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonLike(String value) {
            addCriterion("CPERSON like", value, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonNotLike(String value) {
            addCriterion("CPERSON not like", value, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonIn(List<String> values) {
            addCriterion("CPERSON in", values, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonNotIn(List<String> values) {
            addCriterion("CPERSON not in", values, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonBetween(String value1, String value2) {
            addCriterion("CPERSON between", value1, value2, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonNotBetween(String value1, String value2) {
            addCriterion("CPERSON not between", value1, value2, "cperson");
            return (Criteria) this;
        }

        public Criteria andIsrawIsNull() {
            addCriterion("ISRAW is null");
            return (Criteria) this;
        }

        public Criteria andIsrawIsNotNull() {
            addCriterion("ISRAW is not null");
            return (Criteria) this;
        }

        public Criteria andIsrawEqualTo(Integer value) {
            addCriterion("ISRAW =", value, "israw");
            return (Criteria) this;
        }

        public Criteria andIsrawNotEqualTo(Integer value) {
            addCriterion("ISRAW <>", value, "israw");
            return (Criteria) this;
        }

        public Criteria andIsrawGreaterThan(Integer value) {
            addCriterion("ISRAW >", value, "israw");
            return (Criteria) this;
        }

        public Criteria andIsrawGreaterThanOrEqualTo(Integer value) {
            addCriterion("ISRAW >=", value, "israw");
            return (Criteria) this;
        }

        public Criteria andIsrawLessThan(Integer value) {
            addCriterion("ISRAW <", value, "israw");
            return (Criteria) this;
        }

        public Criteria andIsrawLessThanOrEqualTo(Integer value) {
            addCriterion("ISRAW <=", value, "israw");
            return (Criteria) this;
        }

        public Criteria andIsrawIn(List<Integer> values) {
            addCriterion("ISRAW in", values, "israw");
            return (Criteria) this;
        }

        public Criteria andIsrawNotIn(List<Integer> values) {
            addCriterion("ISRAW not in", values, "israw");
            return (Criteria) this;
        }

        public Criteria andIsrawBetween(Integer value1, Integer value2) {
            addCriterion("ISRAW between", value1, value2, "israw");
            return (Criteria) this;
        }

        public Criteria andIsrawNotBetween(Integer value1, Integer value2) {
            addCriterion("ISRAW not between", value1, value2, "israw");
            return (Criteria) this;
        }

        public Criteria andContractNoIsNull() {
            addCriterion("CONTRACT_NO is null");
            return (Criteria) this;
        }

        public Criteria andContractNoIsNotNull() {
            addCriterion("CONTRACT_NO is not null");
            return (Criteria) this;
        }

        public Criteria andContractNoEqualTo(String value) {
            addCriterion("CONTRACT_NO =", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoNotEqualTo(String value) {
            addCriterion("CONTRACT_NO <>", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoGreaterThan(String value) {
            addCriterion("CONTRACT_NO >", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoGreaterThanOrEqualTo(String value) {
            addCriterion("CONTRACT_NO >=", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoLessThan(String value) {
            addCriterion("CONTRACT_NO <", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoLessThanOrEqualTo(String value) {
            addCriterion("CONTRACT_NO <=", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoLike(String value) {
            addCriterion("CONTRACT_NO like", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoNotLike(String value) {
            addCriterion("CONTRACT_NO not like", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoIn(List<String> values) {
            addCriterion("CONTRACT_NO in", values, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoNotIn(List<String> values) {
            addCriterion("CONTRACT_NO not in", values, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoBetween(String value1, String value2) {
            addCriterion("CONTRACT_NO between", value1, value2, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoNotBetween(String value1, String value2) {
            addCriterion("CONTRACT_NO not between", value1, value2, "contractNo");
            return (Criteria) this;
        }

        public Criteria andFJMoneyIsNull() {
            addCriterion("F_J_MONEY is null");
            return (Criteria) this;
        }

        public Criteria andFJMoneyIsNotNull() {
            addCriterion("F_J_MONEY is not null");
            return (Criteria) this;
        }

        public Criteria andFJMoneyEqualTo(Double value) {
            addCriterion("F_J_MONEY =", value, "fJMoney");
            return (Criteria) this;
        }

        public Criteria andFJMoneyNotEqualTo(Double value) {
            addCriterion("F_J_MONEY <>", value, "fJMoney");
            return (Criteria) this;
        }

        public Criteria andFJMoneyGreaterThan(Double value) {
            addCriterion("F_J_MONEY >", value, "fJMoney");
            return (Criteria) this;
        }

        public Criteria andFJMoneyGreaterThanOrEqualTo(Double value) {
            addCriterion("F_J_MONEY >=", value, "fJMoney");
            return (Criteria) this;
        }

        public Criteria andFJMoneyLessThan(Double value) {
            addCriterion("F_J_MONEY <", value, "fJMoney");
            return (Criteria) this;
        }

        public Criteria andFJMoneyLessThanOrEqualTo(Double value) {
            addCriterion("F_J_MONEY <=", value, "fJMoney");
            return (Criteria) this;
        }

        public Criteria andFJMoneyIn(List<Double> values) {
            addCriterion("F_J_MONEY in", values, "fJMoney");
            return (Criteria) this;
        }

        public Criteria andFJMoneyNotIn(List<Double> values) {
            addCriterion("F_J_MONEY not in", values, "fJMoney");
            return (Criteria) this;
        }

        public Criteria andFJMoneyBetween(Double value1, Double value2) {
            addCriterion("F_J_MONEY between", value1, value2, "fJMoney");
            return (Criteria) this;
        }

        public Criteria andFJMoneyNotBetween(Double value1, Double value2) {
            addCriterion("F_J_MONEY not between", value1, value2, "fJMoney");
            return (Criteria) this;
        }

        public Criteria andFJsTimeIsNull() {
            addCriterion("F_JS_TIME is null");
            return (Criteria) this;
        }

        public Criteria andFJsTimeIsNotNull() {
            addCriterion("F_JS_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andFJsTimeEqualTo(Date value) {
            addCriterion("F_JS_TIME =", value, "fJsTime");
            return (Criteria) this;
        }

        public Criteria andFJsTimeNotEqualTo(Date value) {
            addCriterion("F_JS_TIME <>", value, "fJsTime");
            return (Criteria) this;
        }

        public Criteria andFJsTimeGreaterThan(Date value) {
            addCriterion("F_JS_TIME >", value, "fJsTime");
            return (Criteria) this;
        }

        public Criteria andFJsTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("F_JS_TIME >=", value, "fJsTime");
            return (Criteria) this;
        }

        public Criteria andFJsTimeLessThan(Date value) {
            addCriterion("F_JS_TIME <", value, "fJsTime");
            return (Criteria) this;
        }

        public Criteria andFJsTimeLessThanOrEqualTo(Date value) {
            addCriterion("F_JS_TIME <=", value, "fJsTime");
            return (Criteria) this;
        }

        public Criteria andFJsTimeIn(List<Date> values) {
            addCriterion("F_JS_TIME in", values, "fJsTime");
            return (Criteria) this;
        }

        public Criteria andFJsTimeNotIn(List<Date> values) {
            addCriterion("F_JS_TIME not in", values, "fJsTime");
            return (Criteria) this;
        }

        public Criteria andFJsTimeBetween(Date value1, Date value2) {
            addCriterion("F_JS_TIME between", value1, value2, "fJsTime");
            return (Criteria) this;
        }

        public Criteria andFJsTimeNotBetween(Date value1, Date value2) {
            addCriterion("F_JS_TIME not between", value1, value2, "fJsTime");
            return (Criteria) this;
        }

        public Criteria andInvoiceNameIsNull() {
            addCriterion("INVOICE_NAME is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceNameIsNotNull() {
            addCriterion("INVOICE_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceNameEqualTo(String value) {
            addCriterion("INVOICE_NAME =", value, "invoiceName");
            return (Criteria) this;
        }

        public Criteria andInvoiceNameNotEqualTo(String value) {
            addCriterion("INVOICE_NAME <>", value, "invoiceName");
            return (Criteria) this;
        }

        public Criteria andInvoiceNameGreaterThan(String value) {
            addCriterion("INVOICE_NAME >", value, "invoiceName");
            return (Criteria) this;
        }

        public Criteria andInvoiceNameGreaterThanOrEqualTo(String value) {
            addCriterion("INVOICE_NAME >=", value, "invoiceName");
            return (Criteria) this;
        }

        public Criteria andInvoiceNameLessThan(String value) {
            addCriterion("INVOICE_NAME <", value, "invoiceName");
            return (Criteria) this;
        }

        public Criteria andInvoiceNameLessThanOrEqualTo(String value) {
            addCriterion("INVOICE_NAME <=", value, "invoiceName");
            return (Criteria) this;
        }

        public Criteria andInvoiceNameLike(String value) {
            addCriterion("INVOICE_NAME like", value, "invoiceName");
            return (Criteria) this;
        }

        public Criteria andInvoiceNameNotLike(String value) {
            addCriterion("INVOICE_NAME not like", value, "invoiceName");
            return (Criteria) this;
        }

        public Criteria andInvoiceNameIn(List<String> values) {
            addCriterion("INVOICE_NAME in", values, "invoiceName");
            return (Criteria) this;
        }

        public Criteria andInvoiceNameNotIn(List<String> values) {
            addCriterion("INVOICE_NAME not in", values, "invoiceName");
            return (Criteria) this;
        }

        public Criteria andInvoiceNameBetween(String value1, String value2) {
            addCriterion("INVOICE_NAME between", value1, value2, "invoiceName");
            return (Criteria) this;
        }

        public Criteria andInvoiceNameNotBetween(String value1, String value2) {
            addCriterion("INVOICE_NAME not between", value1, value2, "invoiceName");
            return (Criteria) this;
        }

        public Criteria andInvoiceMoneyIsNull() {
            addCriterion("INVOICE_MONEY is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceMoneyIsNotNull() {
            addCriterion("INVOICE_MONEY is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceMoneyEqualTo(Double value) {
            addCriterion("INVOICE_MONEY =", value, "invoiceMoney");
            return (Criteria) this;
        }

        public Criteria andInvoiceMoneyNotEqualTo(Double value) {
            addCriterion("INVOICE_MONEY <>", value, "invoiceMoney");
            return (Criteria) this;
        }

        public Criteria andInvoiceMoneyGreaterThan(Double value) {
            addCriterion("INVOICE_MONEY >", value, "invoiceMoney");
            return (Criteria) this;
        }

        public Criteria andInvoiceMoneyGreaterThanOrEqualTo(Double value) {
            addCriterion("INVOICE_MONEY >=", value, "invoiceMoney");
            return (Criteria) this;
        }

        public Criteria andInvoiceMoneyLessThan(Double value) {
            addCriterion("INVOICE_MONEY <", value, "invoiceMoney");
            return (Criteria) this;
        }

        public Criteria andInvoiceMoneyLessThanOrEqualTo(Double value) {
            addCriterion("INVOICE_MONEY <=", value, "invoiceMoney");
            return (Criteria) this;
        }

        public Criteria andInvoiceMoneyIn(List<Double> values) {
            addCriterion("INVOICE_MONEY in", values, "invoiceMoney");
            return (Criteria) this;
        }

        public Criteria andInvoiceMoneyNotIn(List<Double> values) {
            addCriterion("INVOICE_MONEY not in", values, "invoiceMoney");
            return (Criteria) this;
        }

        public Criteria andInvoiceMoneyBetween(Double value1, Double value2) {
            addCriterion("INVOICE_MONEY between", value1, value2, "invoiceMoney");
            return (Criteria) this;
        }

        public Criteria andInvoiceMoneyNotBetween(Double value1, Double value2) {
            addCriterion("INVOICE_MONEY not between", value1, value2, "invoiceMoney");
            return (Criteria) this;
        }

        public Criteria andAddrIsNull() {
            addCriterion("ADDR is null");
            return (Criteria) this;
        }

        public Criteria andAddrIsNotNull() {
            addCriterion("ADDR is not null");
            return (Criteria) this;
        }

        public Criteria andAddrEqualTo(String value) {
            addCriterion("ADDR =", value, "addr");
            return (Criteria) this;
        }

        public Criteria andAddrNotEqualTo(String value) {
            addCriterion("ADDR <>", value, "addr");
            return (Criteria) this;
        }

        public Criteria andAddrGreaterThan(String value) {
            addCriterion("ADDR >", value, "addr");
            return (Criteria) this;
        }

        public Criteria andAddrGreaterThanOrEqualTo(String value) {
            addCriterion("ADDR >=", value, "addr");
            return (Criteria) this;
        }

        public Criteria andAddrLessThan(String value) {
            addCriterion("ADDR <", value, "addr");
            return (Criteria) this;
        }

        public Criteria andAddrLessThanOrEqualTo(String value) {
            addCriterion("ADDR <=", value, "addr");
            return (Criteria) this;
        }

        public Criteria andAddrLike(String value) {
            addCriterion("ADDR like", value, "addr");
            return (Criteria) this;
        }

        public Criteria andAddrNotLike(String value) {
            addCriterion("ADDR not like", value, "addr");
            return (Criteria) this;
        }

        public Criteria andAddrIn(List<String> values) {
            addCriterion("ADDR in", values, "addr");
            return (Criteria) this;
        }

        public Criteria andAddrNotIn(List<String> values) {
            addCriterion("ADDR not in", values, "addr");
            return (Criteria) this;
        }

        public Criteria andAddrBetween(String value1, String value2) {
            addCriterion("ADDR between", value1, value2, "addr");
            return (Criteria) this;
        }

        public Criteria andAddrNotBetween(String value1, String value2) {
            addCriterion("ADDR not between", value1, value2, "addr");
            return (Criteria) this;
        }

        public Criteria andIsautoIsNull() {
            addCriterion("ISAUTO is null");
            return (Criteria) this;
        }

        public Criteria andIsautoIsNotNull() {
            addCriterion("ISAUTO is not null");
            return (Criteria) this;
        }

        public Criteria andIsautoEqualTo(Integer value) {
            addCriterion("ISAUTO =", value, "isauto");
            return (Criteria) this;
        }

        public Criteria andIsautoNotEqualTo(Integer value) {
            addCriterion("ISAUTO <>", value, "isauto");
            return (Criteria) this;
        }

        public Criteria andIsautoGreaterThan(Integer value) {
            addCriterion("ISAUTO >", value, "isauto");
            return (Criteria) this;
        }

        public Criteria andIsautoGreaterThanOrEqualTo(Integer value) {
            addCriterion("ISAUTO >=", value, "isauto");
            return (Criteria) this;
        }

        public Criteria andIsautoLessThan(Integer value) {
            addCriterion("ISAUTO <", value, "isauto");
            return (Criteria) this;
        }

        public Criteria andIsautoLessThanOrEqualTo(Integer value) {
            addCriterion("ISAUTO <=", value, "isauto");
            return (Criteria) this;
        }

        public Criteria andIsautoIn(List<Integer> values) {
            addCriterion("ISAUTO in", values, "isauto");
            return (Criteria) this;
        }

        public Criteria andIsautoNotIn(List<Integer> values) {
            addCriterion("ISAUTO not in", values, "isauto");
            return (Criteria) this;
        }

        public Criteria andIsautoBetween(Integer value1, Integer value2) {
            addCriterion("ISAUTO between", value1, value2, "isauto");
            return (Criteria) this;
        }

        public Criteria andIsautoNotBetween(Integer value1, Integer value2) {
            addCriterion("ISAUTO not between", value1, value2, "isauto");
            return (Criteria) this;
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table ORDER_PURCHASE
     *
     * @mbg.generated do_not_delete_during_merge Wed Jul 12 08:41:20 CST 2017
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}